package com.iss.okair.db.mapper;

import com.iss.okair.db.entity.Sysdictvalue;
import com.iss.okair.db.entity.SysdictvalueType;
import com.iss.okair.db.mapper.sql.SysdictvalueSQL;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.List;

public interface SysdictvalueMapper {

    //查询权限的接口
    @Select("SELECT DISTINCT typeCode from sysdictvalue")
    List<SysdictvalueType> getdictList();

    //条件查询的接口
    @SelectProvider(type=SysdictvalueSQL.class,method="findDict")
    List<Sysdictvalue> selectByExample(Sysdictvalue example);
    @Select("SELECT *FROM sysdictvalue WHERE typeCode=#{typecode}")
    List<Sysdictvalue>  selectByTypeCode(@Param("typecode")String typecode);
}
